﻿CREATE TABLE [dbo].[mark_Share] (
    [ShareId]     NVARCHAR (64)    NOT NULL,
    [UserId]      UNIQUEIDENTIFIER NOT NULL,
    [Title]       NVARCHAR (256)   NOT NULL,
    [RefShareId]  NVARCHAR (64)    CONSTRAINT [DF_mark_Share_RefShareId] DEFAULT (NULL) NULL,
    [IsUserTitle] BIT              CONSTRAINT [DF_mark_Share_IsUserTitle] DEFAULT ((0)) NOT NULL,
    CONSTRAINT [PK_mark_Share] PRIMARY KEY CLUSTERED ([ShareId] ASC),
    CONSTRAINT [FK_mark_Share_user_User] FOREIGN KEY ([UserId]) REFERENCES [dbo].[user_User] ([UserId])
);




GO
CREATE NONCLUSTERED INDEX [IX_mark_Share_Ref]
    ON [dbo].[mark_Share]([RefShareId] ASC);

